package com.dy.nygl.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import com.dy.nygl.pojo.ReportSummary;

@Repository("reportSummaryDao")
public interface ReportSummaryMapper {
	
    int deleteByPrimaryKey(Integer id);

    int insert(ReportSummary record);

    int insertSelective(ReportSummary record);

    ReportSummary selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(ReportSummary record);

    int updateByPrimaryKey(ReportSummary record);
    
    List<String> selectTimeYear(@Param("time")String time,@Param("type")String type);
    
    List<String> Time();

	List<String> selectTime(@Param("time")String time);
	
	List<ReportSummary> selectAll();
	
	List<String> selectTimeToTotal(@Param("time")String time, @Param("type")String type);
	
	List<String> selectAllToTotal(String time);

	List<String> selectTotalByEnergyType(@Param("type")String energyType,@Param("time")String time);
	
	List<String> selectTotalByBlurryByYear(@Param("time")String time, @Param("type")String type);
	
	List<String> selectTotalByBlurryByMonthTaskName(@Param("time")String time, @Param("type")String type);

	List<ReportSummary> selectTimeMonth(String time);
    
}